USE [QuanLyKho]
GO

DROP TABLE [dbo].[LenhSanXuat_ChiTiet]

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LenhSanXuat_ChiTiet](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IDLenhSanXuat] [bigint] NULL,
	[IDVatTu] [bigint] NULL,
	[S] [float] NULL,
	[M] [float] NULL,
	[L] [float] NULL,
	[XL] [float] NULL,
	[XXL] [float] NULL,
	[DMTT] [float] NULL,
	[TongCan] [float] NULL,
	[SoLuongCan] [float] NULL,
	[DauTam] [nvarchar](200) NULL,
	[MoTa] [nvarchar](200) NULL,
	[GhiChu] [nvarchar](200) NULL,
 CONSTRAINT [PK_LenhSanXuat_ChiTiet] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

DROP TABLE [dbo].[GiaCong_ChiTiet]

GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[GiaCong_ChiTiet](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IDGiaCong] [bigint] NULL,
	[IDVatTu] [bigint] NULL,
	[S] [float] NULL,
	[M] [float] NULL,
	[L] [float] NULL,
	[XL] [float] NULL,
	[XXL] [float] NULL,
	[DMTT] [float] NULL,
	[TongCan] [float] NULL,
	[SoLuongCan] [float] NULL,
	[DauTam] [nvarchar](200) NULL,
	[MoTa] [nvarchar](200) NULL,
	[GhiChu] [nvarchar](200) NULL,
 CONSTRAINT [PK_GiaCong_ChiTiet] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

DROP TABLE [dbo].[Cat_ChiTiet]

GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Cat_ChiTiet](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IDCat] [bigint] NULL,
	[IDVatTu] [bigint] NULL,
	[S] [float] NULL,
	[M] [float] NULL,
	[L] [float] NULL,
	[XL] [float] NULL,
	[XXL] [float] NULL,
	[DMTT] [float] NULL,
	[TongCan] [float] NULL,
	[SoLuongCan] [float] NULL,
	[DauTam] [nvarchar](200) NULL,
	[MoTa] [nvarchar](200) NULL,
	[GhiChu] [nvarchar](200) NULL,
 CONSTRAINT [PK_Cat_ChiTiet] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


